Release 10.1A: OpenEdge Development:
Java Open Clients

Preparing and managing temp-table parameters

Java clients can access 4GL TABLE or TABLE-HANDLE parameters using the following Java classes and interfaces:

INPUT parameters — Any class that implements the java.sql.ResultSet interface.
OUTPUT parameters — An instance of java.sql.ResultSetHolder, which contains a class that implements the com.progress.open4gl.ProResultSet interface, which extends the java.sql.ResultSet interface.
INPUT-OUTPUT parameters — An instance of the com.progress.open4gl.ResultSetHolder class that contains a reference to a client-supported java.sql.ResultSet object instance. On output, the ResultSetHolder contains an instance of com.progress.open4gl.ProResultSet.

For more information on the java.sql.ResultSet interface, see the relevant JavaSoft publications.

Progress provides the abstract class, com.progress.open4gl.InputResultSet, which provides part of an implementation of java.sql.ResultSet. You can extend this class to implement your own input ResultSet objects. For more information, see the "Passing a TABLE or TABLE-HANDLE as an INPUT parameter" section.

The java.sql.ResultSet interface allows you to get the values of columns in the underlying temp-table. The extensions in the ProResultSet interface allow you to get the values of Progress fields, especially array fields, in a more Progress-like manner. For more information on how to access column and field values using the ProResultSet interface, see the "Accessing TABLE or TABLE-HANDLE parameters as OUTPUT" section.